1z0-950: Oracle Cloud Platform Data Management 2018 Associate

FOR OCI CLASSIC ONLY.

You are trying to add access to a particular cloud service and you want to enable port access to your cloud database. Where can you access the automatically created security rules for the Oracle Database Cloud Service?

Compute Cloud Service/Network tab
Database Cloud Service/Instances tab
Java Cloud Service/Orchestrations
Compute Cloud Service/Storage tab
Database Cloud Service/Monitoring application

Correct answer: A

Explanation:

Reference: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/enable-access-port.html

Which two statements are true about the I/O Resource Manager (IORM) in the Exadata Cloud Service? (Choose two.)

IORM shares out available I/O resources using shares.
To implement a custom IORM plan, a service request is required.
IORM controls the amount of I/O that a single database query can do.
IORM is configured by using the database resource manager.

Correct answer: AB

Which two statements are true about configuring IORM? (Choose two.)

IORM will only intervene when I/O resources become limited.
Each database is allocated a share value between 1 and 64.
If an Exadata Service has three databases, one with a share value of 2, another with a share value of 4, and the third with a share value of 1, the first database will get two I/Os out of every seven, the second database four I/Os out of every seven, and the last database one I/O out of every seven.
If an Exadata Service has three databases, one with a share value of 4, another with a share value of 2, and the third with a share value of 7, and only the first database is doing I/O, it will only receive four I/Os out of every 13.
Custom IORM plans can be created using the ALTER IORMPLAN command from SQL *Plus when connected to one of the instances.

Correct answer: AE

Acme Corporation has two environments: an on-premise Oracle Database environment and a new Oracle Database Cloud environment. Because of this, Acme users have to manage their user accounts and passwords in two places, on premises and in the cloud.

What step should be taken to help eliminate the multiple sign-on, multiple password issue?

Acme should assign an identity domain administrator and instruct him/her to duplicate the on-premises accounts to the cloud, and then send emails to the users instructing them to duplicate their passwords.
Enable federated login by establishing the Federated User Login and pointing all on-premises accounts to the federated login account.
Identity federation is not possible between Oracle environments on premises and in the cloud.
When the service account is created, the service administrator can automatically connect the on-premises domain with the newly created cloud service domain by selecting the Federated Login Required check box and filling in the domain name.
Acme could implement identity federation between the on-premises and cloud environments to achieve single sign on.

Correct answer: E

You want to define an Oracle SQL Developer connection to your Database Cloud Service database. Due to security requirements in your company, you must define an SSH connection in Oracle SQL Developer.

Which two values do you need to provide as part of the SSH connection definition? (Choose two.)

The public SSH key file for your database deployment.
The private SSH key file for your database deployment.
The port number of the listener on your database deployment.
The name of the pre-created security rule for the listener.
The IP address of the compute node hosting your Database Cloud Service database.

Correct answer: BC

Explanation:

Reference: https://blogs.oracle.com/dbaas/connecting-to-a-database-cloud-service-with-sql-developer-and-ssh

Your customer is planning to run both 12.1 and 12.2 databases on their Exadata Cloud Service. They have provisioned an instance and it is your responsibility to create the database deployments.

Which two statements are true? (Choose two.)

If you create the 12.1 database deployment first, you will not be able to create a 12.2 deployment.
You should always create the highest expected database deployment first.
It does not matter in which order you create the database deployments.
You can have multiple grid infrastructure versions running on the Exadata Cloud Service instance.
If you create the 12.1 database deployment first, and then the 12.2 deployment, the Oracle Grid Infrastructure will be automatically upgraded to 12.2.
A single SSH key pair can be used for both database deployments.

Correct answer: BD

Your newly created MySQL Cloud Service is not available from your application. Select the two correct options that apply. (Choose two.)

The MySQL instance is still in the “Creation” process.
The ‘opc’ user can be used to access MySQL only with the created SSH-Key.
You forgot to create the correct SSL/TLC certificate during the setup process.
Only ‘root’ is allowed to access from non-localhost.
You forgot to enable port 3306.

Correct answer: AE

An important client that you’ve recently begun working with is interested in moving some of their on-premises databases into the cloud. How do they determine the correct instance size for their initial deployment?

You should advise your customer to select the largest shape with lots of OCPUs and a high memory count. They can run their database on the larger shape and monitor it to determine the optimum values and then downsize when they’re sure they’ve got it right.
The client should consider the nature of their applications, number of users, and future load scale and select a shape that meets those requirements with a buffer for load spikes. A good starting point could be one that closely matches their on-premises hardware.
The only reason to move to the cloud is if the customer’s on-premises hardware is older and running out of gas. Since the Oracle Database Cloud runs on the latest Intel chips and the fastest available memory, they can safely provision with less than 10% of their current on-premises hardware capacity and be sure that their database will run at its fastest.
The client should carefully consider the nature of their applications, number of users, and run tests to try and predict their future workload size. They should then select a shape that will comfortably run their workload for the next few years because once they’ve selected a shape and instance size the only way to change is to delete the instance and redeploy.
Since they’re moving on-premises databases to the cloud, they’ll obviously want to utilize high memory shapes because everyone can use more memory and that’s the best platform for the future.

Correct answer: B

Your company has purchased a Quarter Rack X6 Exadata Service. The service instance has been created. You are required to provision an 11.2.0.4 database service. Which two statements are true? (Choose two.)

You can choose a single instance database if required.
When the database is created, a new VM will be created to host it.
The Oracle Software Edition is automatically set to High Performance.
The standard billing frequency is hourly but you can choose monthly if required.
If the Both Cloud Storage and Exadata Storage option is not available, it is because this was not chosen during the provisioning of the Exadata cloud service instance.
When the database is created a new Oracle Home will be provisioned.

Correct answer: DE

When deploying Oracle Database products in the Oracle Database cloud, what is the division of security between the customer and Oracle?

In the public cloud model, Oracle is responsible for maintaining all credentials, ssh keys, and customer employee accounts and all activities that occur under those accounts.
The customer is responsible for the entire stack from the underlying cloud infrastructure to identity, networking, and operating system rules and configuration.
Oracle Cloud platform services operate under a shared responsibility model where Oracle is responsible for the underlying cloud infrastructure and the customer is responsible for securing their own workloads under the Oracle Database Cloud.
Oracle is completely responsible for all levels from the underlying cloud infrastructure to identity, networking, and operating system rules and configuration.
Oracle is responsible for Data Security while the customer is responsible for the database, Java, and other infrastructure services.

Correct answer: C

Vendor:	Oracle
Exam Code:	1z0-950
Exam Name:	Oracle Cloud Platform Data Management 2018 Associate
Date:	Sep 10, 2018
File Size:	112 KB

Download Oracle Cloud Platform Data Management 2018 Associate.1z0-950.PracticeTest.2018-09-10.39q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown